package org.jeecg.modules.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public interface HcDailyOrderStatisticMapper extends BaseMapper {

    List<HashMap<String,Object>> queryAllSites();

    // 根据站点id，查询各个站点下的所有写字楼
    List<HashMap<String,Object>> queryOfficeBuildingBySiteId(@Param("siteId")String siteId);

    List<Map<String,Object>> queryDailyOrderCountByBuildingId(@Param("buildingId") String buildingId, @Param("startTime") String startTime, @Param("endTime") String endTime);

    // 获取某个指定的大厦，当天的总订单数，包括大厦的所有楼层的订单
    Integer queryDailyBuildingTotalOrderCount(@Param("buildingId") String buildingId, @Param("startTime") String startTime, @Param("endTime") String endTime);
}
